﻿<?xml version="1.0" encoding="UTF-8"?>
<form xmlns="http://www.evolutility.com" title="工艺流程定义" icon="cube.gif" description="">
  <data dbtable="MRP_MaterialMain" splogin="asp.net membership" dbwhere="MType=5" dbcolumnpk="ID" sppaging="EvoSP_PagedItem @SQLselect, @SQLtable, @SQLfrom, @SQLwhere, @SQLorderby, @SQLpk, @pageid, @pagesize" />
  <panel userid="1" label="基本信息" width="80">
    <field id="85" type="text" typeid="5" label="物料编码" dbcolumn="MCode" dbcolumnread="MCode" maxlength="32" readonly="1" required="1" optional="" fpos="10" search="1" searchadv="1" searchlist="1" height="1" width="40" />
    <field id="38" type="lov" typeid="5" label="物料种类" dbcolumn="MType" dbcolumnread="MaterialType"
  dbtablelov="View_MaterialType_List" dbcolumnreadlov="DisplayText" maxlength="0" readonly="2" required="1" optional="" fpos="30" search="0" searchadv="1" searchlist="1" height="1" width="10" />
    <field id="1292" type="text" typeid="5" label="图纸编码" dbcolumn="DiagramCode" dbcolumnread="DiagramCode" maxlength="50" readonly="1" required="" optional="" fpos="80" search="0" searchadv="1" searchlist="1" height="1" width="20" />
    <field id="238" type="lov" typeid="5" label="型号大小" dbcolumn="SizeType" dborderlov ="ID" dbcolumnread="MaterialSizeType"
 dbtablelov="View_ProductSize_List" dbcolumnreadlov="DisplayText" maxlength="0" readonly="1" required="0" optional="" fpos="30" search="1" searchadv="1" searchlist="1" height="1" width="10" />
    <field id="103" type="textmultiline" typeid="6" label="规格" dbcolumn="Specification" dbcolumnread="Specification" maxlength="256" readonly="1" required="1" optional="" fpos="190" search="0" searchadv="1" searchlist="1" height="2" width="60" />
    <field id="101" type="decimal" typeid="10" label="单重(kg)" dbcolumn="Weight" defaultvalue="0" dbcolumnread="Weight" maxlength="8" readonly="1" required="" optional="" fpos="170" search="0" searchadv="1" searchlist="1" height="1" width="20" />
  </panel>
  <panel-details panelid="2" userid="1" ppos="1" label="工艺流程定义" width="100" dborder="ProcessOrder" dbtabledetails="MRP_Process" dbcolumndetails="ProductID">
    <field id="147" panelid="2" type="integer" typeid="10" label="工序顺序" dbcolumn="ProcessOrder" dbcolumnread="ProcessOrder" maxlength="2" readonly="0" required="1" optional="" fpos="30" search="1" searchadv="1" searchlist="1" height="1" width="20" />
    <field id="155" panelid="2" type="lov" typeid="5" label="工序名称" dbcolumn="Name" dbcolumnread="DisplayText"
   dbtablelov="View_ProcessName_List" dbcolumnreadlov="DisplayText" maxlength="0" readonly="0" required="1" optional="" fpos="30" search="0" searchadv="1" searchlist="0" height="1" width="20" />
    <field id="38" panelid="2"  type="lov" typeid="5" label="计费类型" dbcolumn="CostType" dbcolumnread="ProcessCostType"
   dbtablelov="View_ProcessCostType_List" dbcolumnreadlov="ProcessCostType" maxlength="0" readonly="0" required="1" optional="" fpos="30" search="0" searchadv="1" searchlist="1" height="1" width="20" />
    <field id="172" panelid="2" type="decimal" typeid="9" label="单件成本(￥元)" format="￥#,##0.000000" dbcolumn="Cost" dbcolumnread="Cost" maxlength="6" readonly="0" required="1" optional="" fpos="290" search="" searchadv="1" searchlist="" height="1" width="10" />
    <field id="190" panelid="2" type="boolean" typeid="10" label="是否计入流程单" dbcolumn="IsCounted" img="checkb.gif" defaultvalue="1" dbcolumnread="IsCounted" maxlength="1" readonly="0" required="1" optional="" fpos="60" search="1" searchadv="1" searchlist="" height="1" width="5" />
    <field id="173" panelid="2" type="textmultiline" typeid="6" label="加工要求" dbcolumn="ShortDesc" dbcolumnread="ShortDesc" maxlength="256" readonly="0" required="" optional="" fpos="50" search="1" searchadv="1" searchlist="1" height="1" width="30" />
    <field id="174" panelid="2" type="decimal" typeid="9" label="报废率上限（‰）" format="#,##0.00" dbcolumn="FaultRate" dbcolumnread="FaultRate" maxlength="6" readonly="0" required="" optional="" fpos="60" search="1" searchadv="1" searchlist="1" height="1" width="10" />
    <field id="175" panelid="2" type="decimal" typeid="9" label="不良率上限（‰）" format="#,##0.00" dbcolumn="RejectionRate" dbcolumnread="RejectionRate" maxlength="6" readonly="0" required="" optional="" fpos="70" search="1" searchadv="1" searchlist="1" height="1" width="10" />
  </panel-details>
  <queries label="预定义的查询">
    <query label="没有定义工艺流程的产品" dbwhere="not exists(Select ID from MRP_Process where ProductID=T.ID)" url="product" />
  </queries>
</form>
